NCELKLE SQL MANAGEMET STUDO GDLR TREX DATABASE 'NDE NEW QUERY DENR.
QUERY AAIDAK SORGUYU KOPYALA DAHA SONRA ALITIR.

CREATE VIEW VU_KULLANICIISLEM AS SELECT     TOP (100) PERCENT RT.DESCRIPTION AS MODUL, LF.COMPANYID AS SIRKET, USR.USERNAME AS KULLANICI, LF.TRANS AS ISLEM, 
                      dbo.GETTREXDATE(LF.TRANSDATE) AS TARIH, COUNT(*) AS ISLEMSAYISI, DATEPART(YY, LF.TRANSDATE) AS YIL
FROM         dbo.LOGFILE AS LF INNER JOIN
                      dbo.AUTUSERS AS USR ON LF.USERID = USR.USERID INNER JOIN
                      dbo.TRANSROOT AS RT ON LF.FORMID = RT.ROOT
GROUP BY RT.DESCRIPTION, LF.COMPANYID, USR.USERNAME, LF.TRANS, dbo.GETTREXDATE(LF.TRANSDATE), DATEPART(YY, LF.TRANSDATE)
HAVING      (LF.TRANS = 'ekle')
ORDER BY TARIH DESC